uDig

«  Resource Selection page   ::   Contents   ::   Web Feature Server page  »

Teradata page

The Teradata page is used to define a connection to a Teradata database.

Note

Teradata database support is not enabled by default and requires the Teradata extension to be installed prior to use. Please see the Teradata page for more details.

Connecting to a Teradata database

From the Layer menu, go to Add…

Select the entry titled Teradata and click Next.

This page displays basic information required to connect to a Teradata database. Fill out the following form.

Field Description
Host Host name where the database exists. Can be a URL or IP address.
Port Port number on which to connect to the above host. Default is 1025.
Username User name to use to connect to the database.
Password Password associated with the above user.
Store Password If checked, will store the password for future connections.
Remove Connection Will remove an existing connection from the catalog.
Optional Parameters If checked, will display two new options, listed below.
Connection Mode Options are one of ANSI or Teradata
Query Band application The name of the application to be sent as part of the Teradata query band information. Default is uDig.

Previous connections (if any) will be shown in this dialog as well.

Note

It is recommended that the Teradata database schema is named the same as the Teradata user. Failure to do this may cause problems with feature editing and in some cases may even prevent layers from loading properly.

Press Next to connect to the database.

On the next page, details regarding the available databases and layers are displayed. Enter the name of the database you wish to connect to in the Database field and click List.

A list of available spatial tables that can be loaded into uDig will display. Check the box next to each entry for each table to load as a layer, and then click Next.

If you are adding data directly to a map then proceed to the Resource Selection page.

Related concepts

Teradata

Related reference

Add Data wizard

Resource Selection page

«  Resource Selection page   ::   Contents   ::   Web Feature Server page  »